package com.zhongwang.mms.gen.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BShoppingPlanChangeExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BShoppingPlanChangeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSpcIdIsNull() {
            addCriterion("spc_id is null");
            return (Criteria) this;
        }

        public Criteria andSpcIdIsNotNull() {
            addCriterion("spc_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpcIdEqualTo(Integer value) {
            addCriterion("spc_id =", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdNotEqualTo(Integer value) {
            addCriterion("spc_id <>", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdGreaterThan(Integer value) {
            addCriterion("spc_id >", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_id >=", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdLessThan(Integer value) {
            addCriterion("spc_id <", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdLessThanOrEqualTo(Integer value) {
            addCriterion("spc_id <=", value, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdIn(List<Integer> values) {
            addCriterion("spc_id in", values, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdNotIn(List<Integer> values) {
            addCriterion("spc_id not in", values, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdBetween(Integer value1, Integer value2) {
            addCriterion("spc_id between", value1, value2, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_id not between", value1, value2, "spcId");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeIsNull() {
            addCriterion("spc_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeIsNotNull() {
            addCriterion("spc_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeEqualTo(String value) {
            addCriterion("spc_mat_code =", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeNotEqualTo(String value) {
            addCriterion("spc_mat_code <>", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeGreaterThan(String value) {
            addCriterion("spc_mat_code >", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spc_mat_code >=", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeLessThan(String value) {
            addCriterion("spc_mat_code <", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeLessThanOrEqualTo(String value) {
            addCriterion("spc_mat_code <=", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeLike(String value) {
            addCriterion("spc_mat_code like", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeNotLike(String value) {
            addCriterion("spc_mat_code not like", value, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeIn(List<String> values) {
            addCriterion("spc_mat_code in", values, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeNotIn(List<String> values) {
            addCriterion("spc_mat_code not in", values, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeBetween(String value1, String value2) {
            addCriterion("spc_mat_code between", value1, value2, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatCodeNotBetween(String value1, String value2) {
            addCriterion("spc_mat_code not between", value1, value2, "spcMatCode");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescIsNull() {
            addCriterion("spc_mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescIsNotNull() {
            addCriterion("spc_mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescEqualTo(String value) {
            addCriterion("spc_mat_desc =", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescNotEqualTo(String value) {
            addCriterion("spc_mat_desc <>", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescGreaterThan(String value) {
            addCriterion("spc_mat_desc >", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("spc_mat_desc >=", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescLessThan(String value) {
            addCriterion("spc_mat_desc <", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescLessThanOrEqualTo(String value) {
            addCriterion("spc_mat_desc <=", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescLike(String value) {
            addCriterion("spc_mat_desc like", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescNotLike(String value) {
            addCriterion("spc_mat_desc not like", value, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescIn(List<String> values) {
            addCriterion("spc_mat_desc in", values, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescNotIn(List<String> values) {
            addCriterion("spc_mat_desc not in", values, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescBetween(String value1, String value2) {
            addCriterion("spc_mat_desc between", value1, value2, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcMatDescNotBetween(String value1, String value2) {
            addCriterion("spc_mat_desc not between", value1, value2, "spcMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNumIsNull() {
            addCriterion("spc_num is null");
            return (Criteria) this;
        }

        public Criteria andSpcNumIsNotNull() {
            addCriterion("spc_num is not null");
            return (Criteria) this;
        }

        public Criteria andSpcNumEqualTo(Double value) {
            addCriterion("spc_num =", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumNotEqualTo(Double value) {
            addCriterion("spc_num <>", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumGreaterThan(Double value) {
            addCriterion("spc_num >", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumGreaterThanOrEqualTo(Double value) {
            addCriterion("spc_num >=", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumLessThan(Double value) {
            addCriterion("spc_num <", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumLessThanOrEqualTo(Double value) {
            addCriterion("spc_num <=", value, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumIn(List<Double> values) {
            addCriterion("spc_num in", values, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumNotIn(List<Double> values) {
            addCriterion("spc_num not in", values, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumBetween(Double value1, Double value2) {
            addCriterion("spc_num between", value1, value2, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNumNotBetween(Double value1, Double value2) {
            addCriterion("spc_num not between", value1, value2, "spcNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumIsNull() {
            addCriterion("spc_new_num is null");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumIsNotNull() {
            addCriterion("spc_new_num is not null");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumEqualTo(Double value) {
            addCriterion("spc_new_num =", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumNotEqualTo(Double value) {
            addCriterion("spc_new_num <>", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumGreaterThan(Double value) {
            addCriterion("spc_new_num >", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumGreaterThanOrEqualTo(Double value) {
            addCriterion("spc_new_num >=", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumLessThan(Double value) {
            addCriterion("spc_new_num <", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumLessThanOrEqualTo(Double value) {
            addCriterion("spc_new_num <=", value, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumIn(List<Double> values) {
            addCriterion("spc_new_num in", values, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumNotIn(List<Double> values) {
            addCriterion("spc_new_num not in", values, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumBetween(Double value1, Double value2) {
            addCriterion("spc_new_num between", value1, value2, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcNewNumNotBetween(Double value1, Double value2) {
            addCriterion("spc_new_num not between", value1, value2, "spcNewNum");
            return (Criteria) this;
        }

        public Criteria andSpcUnitIsNull() {
            addCriterion("spc_unit is null");
            return (Criteria) this;
        }

        public Criteria andSpcUnitIsNotNull() {
            addCriterion("spc_unit is not null");
            return (Criteria) this;
        }

        public Criteria andSpcUnitEqualTo(String value) {
            addCriterion("spc_unit =", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitNotEqualTo(String value) {
            addCriterion("spc_unit <>", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitGreaterThan(String value) {
            addCriterion("spc_unit >", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitGreaterThanOrEqualTo(String value) {
            addCriterion("spc_unit >=", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitLessThan(String value) {
            addCriterion("spc_unit <", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitLessThanOrEqualTo(String value) {
            addCriterion("spc_unit <=", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitLike(String value) {
            addCriterion("spc_unit like", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitNotLike(String value) {
            addCriterion("spc_unit not like", value, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitIn(List<String> values) {
            addCriterion("spc_unit in", values, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitNotIn(List<String> values) {
            addCriterion("spc_unit not in", values, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitBetween(String value1, String value2) {
            addCriterion("spc_unit between", value1, value2, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcUnitNotBetween(String value1, String value2) {
            addCriterion("spc_unit not between", value1, value2, "spcUnit");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoIsNull() {
            addCriterion("spc_standard_no is null");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoIsNotNull() {
            addCriterion("spc_standard_no is not null");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoEqualTo(String value) {
            addCriterion("spc_standard_no =", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoNotEqualTo(String value) {
            addCriterion("spc_standard_no <>", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoGreaterThan(String value) {
            addCriterion("spc_standard_no >", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoGreaterThanOrEqualTo(String value) {
            addCriterion("spc_standard_no >=", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoLessThan(String value) {
            addCriterion("spc_standard_no <", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoLessThanOrEqualTo(String value) {
            addCriterion("spc_standard_no <=", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoLike(String value) {
            addCriterion("spc_standard_no like", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoNotLike(String value) {
            addCriterion("spc_standard_no not like", value, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoIn(List<String> values) {
            addCriterion("spc_standard_no in", values, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoNotIn(List<String> values) {
            addCriterion("spc_standard_no not in", values, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoBetween(String value1, String value2) {
            addCriterion("spc_standard_no between", value1, value2, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcStandardNoNotBetween(String value1, String value2) {
            addCriterion("spc_standard_no not between", value1, value2, "spcStandardNo");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryIsNull() {
            addCriterion("spc_category is null");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryIsNotNull() {
            addCriterion("spc_category is not null");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryEqualTo(String value) {
            addCriterion("spc_category =", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryNotEqualTo(String value) {
            addCriterion("spc_category <>", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryGreaterThan(String value) {
            addCriterion("spc_category >", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("spc_category >=", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryLessThan(String value) {
            addCriterion("spc_category <", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryLessThanOrEqualTo(String value) {
            addCriterion("spc_category <=", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryLike(String value) {
            addCriterion("spc_category like", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryNotLike(String value) {
            addCriterion("spc_category not like", value, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryIn(List<String> values) {
            addCriterion("spc_category in", values, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryNotIn(List<String> values) {
            addCriterion("spc_category not in", values, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryBetween(String value1, String value2) {
            addCriterion("spc_category between", value1, value2, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcCategoryNotBetween(String value1, String value2) {
            addCriterion("spc_category not between", value1, value2, "spcCategory");
            return (Criteria) this;
        }

        public Criteria andSpcBrandIsNull() {
            addCriterion("spc_brand is null");
            return (Criteria) this;
        }

        public Criteria andSpcBrandIsNotNull() {
            addCriterion("spc_brand is not null");
            return (Criteria) this;
        }

        public Criteria andSpcBrandEqualTo(String value) {
            addCriterion("spc_brand =", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandNotEqualTo(String value) {
            addCriterion("spc_brand <>", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandGreaterThan(String value) {
            addCriterion("spc_brand >", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandGreaterThanOrEqualTo(String value) {
            addCriterion("spc_brand >=", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandLessThan(String value) {
            addCriterion("spc_brand <", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandLessThanOrEqualTo(String value) {
            addCriterion("spc_brand <=", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandLike(String value) {
            addCriterion("spc_brand like", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandNotLike(String value) {
            addCriterion("spc_brand not like", value, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandIn(List<String> values) {
            addCriterion("spc_brand in", values, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandNotIn(List<String> values) {
            addCriterion("spc_brand not in", values, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandBetween(String value1, String value2) {
            addCriterion("spc_brand between", value1, value2, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcBrandNotBetween(String value1, String value2) {
            addCriterion("spc_brand not between", value1, value2, "spcBrand");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkIsNull() {
            addCriterion("spc_remark is null");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkIsNotNull() {
            addCriterion("spc_remark is not null");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkEqualTo(String value) {
            addCriterion("spc_remark =", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkNotEqualTo(String value) {
            addCriterion("spc_remark <>", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkGreaterThan(String value) {
            addCriterion("spc_remark >", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("spc_remark >=", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkLessThan(String value) {
            addCriterion("spc_remark <", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkLessThanOrEqualTo(String value) {
            addCriterion("spc_remark <=", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkLike(String value) {
            addCriterion("spc_remark like", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkNotLike(String value) {
            addCriterion("spc_remark not like", value, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkIn(List<String> values) {
            addCriterion("spc_remark in", values, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkNotIn(List<String> values) {
            addCriterion("spc_remark not in", values, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkBetween(String value1, String value2) {
            addCriterion("spc_remark between", value1, value2, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcRemarkNotBetween(String value1, String value2) {
            addCriterion("spc_remark not between", value1, value2, "spcRemark");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameIsNull() {
            addCriterion("spc_project_name is null");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameIsNotNull() {
            addCriterion("spc_project_name is not null");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameEqualTo(String value) {
            addCriterion("spc_project_name =", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameNotEqualTo(String value) {
            addCriterion("spc_project_name <>", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameGreaterThan(String value) {
            addCriterion("spc_project_name >", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("spc_project_name >=", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameLessThan(String value) {
            addCriterion("spc_project_name <", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameLessThanOrEqualTo(String value) {
            addCriterion("spc_project_name <=", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameLike(String value) {
            addCriterion("spc_project_name like", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameNotLike(String value) {
            addCriterion("spc_project_name not like", value, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameIn(List<String> values) {
            addCriterion("spc_project_name in", values, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameNotIn(List<String> values) {
            addCriterion("spc_project_name not in", values, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameBetween(String value1, String value2) {
            addCriterion("spc_project_name between", value1, value2, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectNameNotBetween(String value1, String value2) {
            addCriterion("spc_project_name not between", value1, value2, "spcProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeIsNull() {
            addCriterion("spc_project_code is null");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeIsNotNull() {
            addCriterion("spc_project_code is not null");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeEqualTo(String value) {
            addCriterion("spc_project_code =", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeNotEqualTo(String value) {
            addCriterion("spc_project_code <>", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeGreaterThan(String value) {
            addCriterion("spc_project_code >", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spc_project_code >=", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeLessThan(String value) {
            addCriterion("spc_project_code <", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeLessThanOrEqualTo(String value) {
            addCriterion("spc_project_code <=", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeLike(String value) {
            addCriterion("spc_project_code like", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeNotLike(String value) {
            addCriterion("spc_project_code not like", value, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeIn(List<String> values) {
            addCriterion("spc_project_code in", values, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeNotIn(List<String> values) {
            addCriterion("spc_project_code not in", values, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeBetween(String value1, String value2) {
            addCriterion("spc_project_code between", value1, value2, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcProjectCodeNotBetween(String value1, String value2) {
            addCriterion("spc_project_code not between", value1, value2, "spcProjectCode");
            return (Criteria) this;
        }

        public Criteria andSpcPartIsNull() {
            addCriterion("spc_part is null");
            return (Criteria) this;
        }

        public Criteria andSpcPartIsNotNull() {
            addCriterion("spc_part is not null");
            return (Criteria) this;
        }

        public Criteria andSpcPartEqualTo(String value) {
            addCriterion("spc_part =", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartNotEqualTo(String value) {
            addCriterion("spc_part <>", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartGreaterThan(String value) {
            addCriterion("spc_part >", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartGreaterThanOrEqualTo(String value) {
            addCriterion("spc_part >=", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartLessThan(String value) {
            addCriterion("spc_part <", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartLessThanOrEqualTo(String value) {
            addCriterion("spc_part <=", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartLike(String value) {
            addCriterion("spc_part like", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartNotLike(String value) {
            addCriterion("spc_part not like", value, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartIn(List<String> values) {
            addCriterion("spc_part in", values, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartNotIn(List<String> values) {
            addCriterion("spc_part not in", values, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartBetween(String value1, String value2) {
            addCriterion("spc_part between", value1, value2, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcPartNotBetween(String value1, String value2) {
            addCriterion("spc_part not between", value1, value2, "spcPart");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerIsNull() {
            addCriterion("spc_designer is null");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerIsNotNull() {
            addCriterion("spc_designer is not null");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerEqualTo(String value) {
            addCriterion("spc_designer =", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerNotEqualTo(String value) {
            addCriterion("spc_designer <>", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerGreaterThan(String value) {
            addCriterion("spc_designer >", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerGreaterThanOrEqualTo(String value) {
            addCriterion("spc_designer >=", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerLessThan(String value) {
            addCriterion("spc_designer <", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerLessThanOrEqualTo(String value) {
            addCriterion("spc_designer <=", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerLike(String value) {
            addCriterion("spc_designer like", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerNotLike(String value) {
            addCriterion("spc_designer not like", value, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerIn(List<String> values) {
            addCriterion("spc_designer in", values, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerNotIn(List<String> values) {
            addCriterion("spc_designer not in", values, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerBetween(String value1, String value2) {
            addCriterion("spc_designer between", value1, value2, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcDesignerNotBetween(String value1, String value2) {
            addCriterion("spc_designer not between", value1, value2, "spcDesigner");
            return (Criteria) this;
        }

        public Criteria andSpcTelIsNull() {
            addCriterion("spc_tel is null");
            return (Criteria) this;
        }

        public Criteria andSpcTelIsNotNull() {
            addCriterion("spc_tel is not null");
            return (Criteria) this;
        }

        public Criteria andSpcTelEqualTo(String value) {
            addCriterion("spc_tel =", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelNotEqualTo(String value) {
            addCriterion("spc_tel <>", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelGreaterThan(String value) {
            addCriterion("spc_tel >", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelGreaterThanOrEqualTo(String value) {
            addCriterion("spc_tel >=", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelLessThan(String value) {
            addCriterion("spc_tel <", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelLessThanOrEqualTo(String value) {
            addCriterion("spc_tel <=", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelLike(String value) {
            addCriterion("spc_tel like", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelNotLike(String value) {
            addCriterion("spc_tel not like", value, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelIn(List<String> values) {
            addCriterion("spc_tel in", values, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelNotIn(List<String> values) {
            addCriterion("spc_tel not in", values, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelBetween(String value1, String value2) {
            addCriterion("spc_tel between", value1, value2, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcTelNotBetween(String value1, String value2) {
            addCriterion("spc_tel not between", value1, value2, "spcTel");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerIsNull() {
            addCriterion("spc_buyer is null");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerIsNotNull() {
            addCriterion("spc_buyer is not null");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerEqualTo(String value) {
            addCriterion("spc_buyer =", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerNotEqualTo(String value) {
            addCriterion("spc_buyer <>", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerGreaterThan(String value) {
            addCriterion("spc_buyer >", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerGreaterThanOrEqualTo(String value) {
            addCriterion("spc_buyer >=", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerLessThan(String value) {
            addCriterion("spc_buyer <", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerLessThanOrEqualTo(String value) {
            addCriterion("spc_buyer <=", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerLike(String value) {
            addCriterion("spc_buyer like", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerNotLike(String value) {
            addCriterion("spc_buyer not like", value, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerIn(List<String> values) {
            addCriterion("spc_buyer in", values, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerNotIn(List<String> values) {
            addCriterion("spc_buyer not in", values, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerBetween(String value1, String value2) {
            addCriterion("spc_buyer between", value1, value2, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcBuyerNotBetween(String value1, String value2) {
            addCriterion("spc_buyer not between", value1, value2, "spcBuyer");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleIsNull() {
            addCriterion("spc_pay_cycle is null");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleIsNotNull() {
            addCriterion("spc_pay_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleEqualTo(Integer value) {
            addCriterion("spc_pay_cycle =", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleNotEqualTo(Integer value) {
            addCriterion("spc_pay_cycle <>", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleGreaterThan(Integer value) {
            addCriterion("spc_pay_cycle >", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_pay_cycle >=", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleLessThan(Integer value) {
            addCriterion("spc_pay_cycle <", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleLessThanOrEqualTo(Integer value) {
            addCriterion("spc_pay_cycle <=", value, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleIn(List<Integer> values) {
            addCriterion("spc_pay_cycle in", values, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleNotIn(List<Integer> values) {
            addCriterion("spc_pay_cycle not in", values, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleBetween(Integer value1, Integer value2) {
            addCriterion("spc_pay_cycle between", value1, value2, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcPayCycleNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_pay_cycle not between", value1, value2, "spcPayCycle");
            return (Criteria) this;
        }

        public Criteria andSpcLocationIsNull() {
            addCriterion("spc_location is null");
            return (Criteria) this;
        }

        public Criteria andSpcLocationIsNotNull() {
            addCriterion("spc_location is not null");
            return (Criteria) this;
        }

        public Criteria andSpcLocationEqualTo(String value) {
            addCriterion("spc_location =", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationNotEqualTo(String value) {
            addCriterion("spc_location <>", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationGreaterThan(String value) {
            addCriterion("spc_location >", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationGreaterThanOrEqualTo(String value) {
            addCriterion("spc_location >=", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationLessThan(String value) {
            addCriterion("spc_location <", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationLessThanOrEqualTo(String value) {
            addCriterion("spc_location <=", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationLike(String value) {
            addCriterion("spc_location like", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationNotLike(String value) {
            addCriterion("spc_location not like", value, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationIn(List<String> values) {
            addCriterion("spc_location in", values, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationNotIn(List<String> values) {
            addCriterion("spc_location not in", values, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationBetween(String value1, String value2) {
            addCriterion("spc_location between", value1, value2, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcLocationNotBetween(String value1, String value2) {
            addCriterion("spc_location not between", value1, value2, "spcLocation");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeIsNull() {
            addCriterion("spc_change_time is null");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeIsNotNull() {
            addCriterion("spc_change_time is not null");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeEqualTo(Date value) {
            addCriterion("spc_change_time =", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeNotEqualTo(Date value) {
            addCriterion("spc_change_time <>", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeGreaterThan(Date value) {
            addCriterion("spc_change_time >", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("spc_change_time >=", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeLessThan(Date value) {
            addCriterion("spc_change_time <", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeLessThanOrEqualTo(Date value) {
            addCriterion("spc_change_time <=", value, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeIn(List<Date> values) {
            addCriterion("spc_change_time in", values, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeNotIn(List<Date> values) {
            addCriterion("spc_change_time not in", values, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeBetween(Date value1, Date value2) {
            addCriterion("spc_change_time between", value1, value2, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcChangeTimeNotBetween(Date value1, Date value2) {
            addCriterion("spc_change_time not between", value1, value2, "spcChangeTime");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusIsNull() {
            addCriterion("spc_import_status is null");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusIsNotNull() {
            addCriterion("spc_import_status is not null");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusEqualTo(Integer value) {
            addCriterion("spc_import_status =", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusNotEqualTo(Integer value) {
            addCriterion("spc_import_status <>", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusGreaterThan(Integer value) {
            addCriterion("spc_import_status >", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_import_status >=", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusLessThan(Integer value) {
            addCriterion("spc_import_status <", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spc_import_status <=", value, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusIn(List<Integer> values) {
            addCriterion("spc_import_status in", values, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusNotIn(List<Integer> values) {
            addCriterion("spc_import_status not in", values, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusBetween(Integer value1, Integer value2) {
            addCriterion("spc_import_status between", value1, value2, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcImportStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_import_status not between", value1, value2, "spcImportStatus");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdIsNull() {
            addCriterion("spc_spi_id is null");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdIsNotNull() {
            addCriterion("spc_spi_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdEqualTo(Integer value) {
            addCriterion("spc_spi_id =", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdNotEqualTo(Integer value) {
            addCriterion("spc_spi_id <>", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdGreaterThan(Integer value) {
            addCriterion("spc_spi_id >", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_spi_id >=", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdLessThan(Integer value) {
            addCriterion("spc_spi_id <", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdLessThanOrEqualTo(Integer value) {
            addCriterion("spc_spi_id <=", value, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdIn(List<Integer> values) {
            addCriterion("spc_spi_id in", values, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdNotIn(List<Integer> values) {
            addCriterion("spc_spi_id not in", values, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdBetween(Integer value1, Integer value2) {
            addCriterion("spc_spi_id between", value1, value2, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSpiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_spi_id not between", value1, value2, "spcSpiId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdIsNull() {
            addCriterion("spc_spp_id is null");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdIsNotNull() {
            addCriterion("spc_spp_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdEqualTo(Integer value) {
            addCriterion("spc_spp_id =", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdNotEqualTo(Integer value) {
            addCriterion("spc_spp_id <>", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdGreaterThan(Integer value) {
            addCriterion("spc_spp_id >", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_spp_id >=", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdLessThan(Integer value) {
            addCriterion("spc_spp_id <", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdLessThanOrEqualTo(Integer value) {
            addCriterion("spc_spp_id <=", value, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdIn(List<Integer> values) {
            addCriterion("spc_spp_id in", values, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdNotIn(List<Integer> values) {
            addCriterion("spc_spp_id not in", values, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdBetween(Integer value1, Integer value2) {
            addCriterion("spc_spp_id between", value1, value2, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcSppIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_spp_id not between", value1, value2, "spcSppId");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagIsNull() {
            addCriterion("spc_change_flag is null");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagIsNotNull() {
            addCriterion("spc_change_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagEqualTo(Integer value) {
            addCriterion("spc_change_flag =", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagNotEqualTo(Integer value) {
            addCriterion("spc_change_flag <>", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagGreaterThan(Integer value) {
            addCriterion("spc_change_flag >", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("spc_change_flag >=", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagLessThan(Integer value) {
            addCriterion("spc_change_flag <", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("spc_change_flag <=", value, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagIn(List<Integer> values) {
            addCriterion("spc_change_flag in", values, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagNotIn(List<Integer> values) {
            addCriterion("spc_change_flag not in", values, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagBetween(Integer value1, Integer value2) {
            addCriterion("spc_change_flag between", value1, value2, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcChangeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("spc_change_flag not between", value1, value2, "spcChangeFlag");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoIsNull() {
            addCriterion("spc_track_no is null");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoIsNotNull() {
            addCriterion("spc_track_no is not null");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoEqualTo(String value) {
            addCriterion("spc_track_no =", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoNotEqualTo(String value) {
            addCriterion("spc_track_no <>", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoGreaterThan(String value) {
            addCriterion("spc_track_no >", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoGreaterThanOrEqualTo(String value) {
            addCriterion("spc_track_no >=", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoLessThan(String value) {
            addCriterion("spc_track_no <", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoLessThanOrEqualTo(String value) {
            addCriterion("spc_track_no <=", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoLike(String value) {
            addCriterion("spc_track_no like", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoNotLike(String value) {
            addCriterion("spc_track_no not like", value, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoIn(List<String> values) {
            addCriterion("spc_track_no in", values, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoNotIn(List<String> values) {
            addCriterion("spc_track_no not in", values, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoBetween(String value1, String value2) {
            addCriterion("spc_track_no between", value1, value2, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcTrackNoNotBetween(String value1, String value2) {
            addCriterion("spc_track_no not between", value1, value2, "spcTrackNo");
            return (Criteria) this;
        }

        public Criteria andSpcReasonIsNull() {
            addCriterion("spc_reason is null");
            return (Criteria) this;
        }

        public Criteria andSpcReasonIsNotNull() {
            addCriterion("spc_reason is not null");
            return (Criteria) this;
        }

        public Criteria andSpcReasonEqualTo(String value) {
            addCriterion("spc_reason =", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonNotEqualTo(String value) {
            addCriterion("spc_reason <>", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonGreaterThan(String value) {
            addCriterion("spc_reason >", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonGreaterThanOrEqualTo(String value) {
            addCriterion("spc_reason >=", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonLessThan(String value) {
            addCriterion("spc_reason <", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonLessThanOrEqualTo(String value) {
            addCriterion("spc_reason <=", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonLike(String value) {
            addCriterion("spc_reason like", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonNotLike(String value) {
            addCriterion("spc_reason not like", value, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonIn(List<String> values) {
            addCriterion("spc_reason in", values, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonNotIn(List<String> values) {
            addCriterion("spc_reason not in", values, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonBetween(String value1, String value2) {
            addCriterion("spc_reason between", value1, value2, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcReasonNotBetween(String value1, String value2) {
            addCriterion("spc_reason not between", value1, value2, "spcReason");
            return (Criteria) this;
        }

        public Criteria andSpcDelIsNull() {
            addCriterion("spc_del is null");
            return (Criteria) this;
        }

        public Criteria andSpcDelIsNotNull() {
            addCriterion("spc_del is not null");
            return (Criteria) this;
        }

        public Criteria andSpcDelEqualTo(String value) {
            addCriterion("spc_del =", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelNotEqualTo(String value) {
            addCriterion("spc_del <>", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelGreaterThan(String value) {
            addCriterion("spc_del >", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelGreaterThanOrEqualTo(String value) {
            addCriterion("spc_del >=", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelLessThan(String value) {
            addCriterion("spc_del <", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelLessThanOrEqualTo(String value) {
            addCriterion("spc_del <=", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelLike(String value) {
            addCriterion("spc_del like", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelNotLike(String value) {
            addCriterion("spc_del not like", value, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelIn(List<String> values) {
            addCriterion("spc_del in", values, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelNotIn(List<String> values) {
            addCriterion("spc_del not in", values, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelBetween(String value1, String value2) {
            addCriterion("spc_del between", value1, value2, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcDelNotBetween(String value1, String value2) {
            addCriterion("spc_del not between", value1, value2, "spcDel");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateIsNull() {
            addCriterion("spc_plan_date is null");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateIsNotNull() {
            addCriterion("spc_plan_date is not null");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateEqualTo(Date value) {
            addCriterion("spc_plan_date =", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateNotEqualTo(Date value) {
            addCriterion("spc_plan_date <>", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateGreaterThan(Date value) {
            addCriterion("spc_plan_date >", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spc_plan_date >=", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateLessThan(Date value) {
            addCriterion("spc_plan_date <", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateLessThanOrEqualTo(Date value) {
            addCriterion("spc_plan_date <=", value, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateIn(List<Date> values) {
            addCriterion("spc_plan_date in", values, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateNotIn(List<Date> values) {
            addCriterion("spc_plan_date not in", values, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateBetween(Date value1, Date value2) {
            addCriterion("spc_plan_date between", value1, value2, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcPlanDateNotBetween(Date value1, Date value2) {
            addCriterion("spc_plan_date not between", value1, value2, "spcPlanDate");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandIsNull() {
            addCriterion("spc_new_brand is null");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandIsNotNull() {
            addCriterion("spc_new_brand is not null");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandEqualTo(String value) {
            addCriterion("spc_new_brand =", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandNotEqualTo(String value) {
            addCriterion("spc_new_brand <>", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandGreaterThan(String value) {
            addCriterion("spc_new_brand >", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandGreaterThanOrEqualTo(String value) {
            addCriterion("spc_new_brand >=", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandLessThan(String value) {
            addCriterion("spc_new_brand <", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandLessThanOrEqualTo(String value) {
            addCriterion("spc_new_brand <=", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandLike(String value) {
            addCriterion("spc_new_brand like", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandNotLike(String value) {
            addCriterion("spc_new_brand not like", value, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandIn(List<String> values) {
            addCriterion("spc_new_brand in", values, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandNotIn(List<String> values) {
            addCriterion("spc_new_brand not in", values, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandBetween(String value1, String value2) {
            addCriterion("spc_new_brand between", value1, value2, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewBrandNotBetween(String value1, String value2) {
            addCriterion("spc_new_brand not between", value1, value2, "spcNewBrand");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameIsNull() {
            addCriterion("spc_new_project_name is null");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameIsNotNull() {
            addCriterion("spc_new_project_name is not null");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameEqualTo(String value) {
            addCriterion("spc_new_project_name =", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameNotEqualTo(String value) {
            addCriterion("spc_new_project_name <>", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameGreaterThan(String value) {
            addCriterion("spc_new_project_name >", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("spc_new_project_name >=", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameLessThan(String value) {
            addCriterion("spc_new_project_name <", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameLessThanOrEqualTo(String value) {
            addCriterion("spc_new_project_name <=", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameLike(String value) {
            addCriterion("spc_new_project_name like", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameNotLike(String value) {
            addCriterion("spc_new_project_name not like", value, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameIn(List<String> values) {
            addCriterion("spc_new_project_name in", values, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameNotIn(List<String> values) {
            addCriterion("spc_new_project_name not in", values, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameBetween(String value1, String value2) {
            addCriterion("spc_new_project_name between", value1, value2, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewProjectNameNotBetween(String value1, String value2) {
            addCriterion("spc_new_project_name not between", value1, value2, "spcNewProjectName");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescIsNull() {
            addCriterion("spc_new_mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescIsNotNull() {
            addCriterion("spc_new_mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescEqualTo(String value) {
            addCriterion("spc_new_mat_desc =", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescNotEqualTo(String value) {
            addCriterion("spc_new_mat_desc <>", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescGreaterThan(String value) {
            addCriterion("spc_new_mat_desc >", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("spc_new_mat_desc >=", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescLessThan(String value) {
            addCriterion("spc_new_mat_desc <", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescLessThanOrEqualTo(String value) {
            addCriterion("spc_new_mat_desc <=", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescLike(String value) {
            addCriterion("spc_new_mat_desc like", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescNotLike(String value) {
            addCriterion("spc_new_mat_desc not like", value, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescIn(List<String> values) {
            addCriterion("spc_new_mat_desc in", values, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescNotIn(List<String> values) {
            addCriterion("spc_new_mat_desc not in", values, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescBetween(String value1, String value2) {
            addCriterion("spc_new_mat_desc between", value1, value2, "spcNewMatDesc");
            return (Criteria) this;
        }

        public Criteria andSpcNewMatDescNotBetween(String value1, String value2) {
            addCriterion("spc_new_mat_desc not between", value1, value2, "spcNewMatDesc");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}